OPTIONS (rows=10000,silent=(ALL),direct=true)
load data
INFILE 'CH_01.txt'
TRUNCATE
CONTINUEIF LAST = '#'
INTO TABLE HIPPO.TEST_TABLE1
WHEN (1) != "BEG" AND (1) != "END"
FIELDS TERMINATED BY ' || '
TRAILING NULLCOLS
(
  AGENTSERIALNO,
  AGENTCODE,
  AGENTNAME,
  BRANCHCODE,
  ONECHNCODE,
  TWOCHNCODE,
  THIRDCHNCODE,
  FOURCHNAPPENDCODE,
  FIVECHNAPPENDCODE,
  SIXCHNAPPENDCODE,
  SEVENCHNAPPENDCODE,
  BANKPAYNO,
  MANAGERCODE, 
  AGENTCLASSES,
  MANAGESTARTDATE date 'yyyy-mm-dd hh24:mi:ss',
  MANAGEENDDATE date 'yyyy-mm-dd hh24:mi:ss',
  STATUS,
  FLAG,
  BALANCINGCYCLE,
  BALANCINGDATE date 'yyyy-mm-dd hh24:mi:ss',
  CREATEDATE date 'yyyy-mm-dd hh24:mi:ss',
  UPDATEDATE date 'yyyy-mm-dd hh24:mi:ss',
  CHANNELCODE,
  CHANNELNAME,
  CHANNELLEVEL,
  NOTEMESSAGE, 
  AGENTTYPE,
  OLDAGENTCODE,
  UNIQUECODE,
  SENDSTATUS,
  WORKDATE,
  POPULATION_TIMESTAMP date 'yyyy-mm-dd hh24:mi:ss',
  IMP_DATE "SYSDATE"
)
